Business Rules for Data Warehouse
نویسنده
چکیده
Business rules and data warehouse are concepts and technologies that impact a wide variety of organizational tasks. In general, each area has evolved independently, impacting application development and decision-making. Generating knowledge from data warehouse is a complex process. This paper outlines an approach to ease import of information and knowledge from a data warehouse star schema through an inference class of business rules. The paper utilizes the Oracle database for illustrating the working of the concepts. The star schema structure and the business rules are stored within a relational database. The approach is explained through a prototype in Oracle’s PL/SQL Server Pages. Keywords—Business Rules, Data warehouse, PL/SQL Server Pages, Relational model, Web Application.
منابع مشابه
Eliciting Data Warehouse Contents for Policy Enforcement Rules
Data Warehouse requirements engineering has been extensively looked at from the ENDS perspective of the Business Motivation Model, in terms of goals the system to-be wants to achieve. The authors propose that the MEANS perspective of this Model can drive the requirements engineering process. MEANS are organized into business policies and ‘policy enforcement rules’. Starting from policies expres...
متن کاملAn Agent-Based Approach for Sourcing Business Rules in Supply Chain Management
In recent years, business rule management has become an important component of enterprise information systems. Business rules represent guidelines about how an enterprise should conduct its business and provide better service for customers. Business rules are being widely deployed in supply chains to support real-time decision making. The research reported in this paper is aimed at designing a ...
متن کاملStructuring Business Metadata in Data Warehouse Systems for Effective Business Support
Large organizations today are being served by different types of data processing and infor-mations systems, ranging from the operational (OLTP) systems, data warehouse systems, to data mining and business intelligence applications. It is important to create an integrated repository of what these system contain and do in order to use them collectively and effectively. The repository contains met...
متن کاملA Convenient Way From Normalized Database To Denormalized Database
Data warehouse is a denormalized and information oriented system used to convert business rules into useful information as it is the collection of archived operational data which is useful in tactical and strategic business decisions. A relational database consists of a collection of tables that store particular sets of data in a form of normalized database. We use ER Model in relational databa...
متن کاملEliciting Information Requirements for DW Systems
Data Warehouse technology addresses business process analysis. However, it ignores upstream decision-making like formulating policies and policy enforcement rules. We provide a requirements engineering approach for building an integrated data for all types of decisions in an organization. To do this, we develop a two level generic platform with the bottom level having generic models of decision...
متن کامل